library(plotly)
## Loading required package: ggplot2
##
## Attaching package: 'plotly'
## The following object is masked from 'package:ggplot2':
##
## last_plot
## The following object is masked from 'package:stats':
##
## filter
## The following object is masked from 'package:graphics':
##
## layout
inner_data = read.csv('../Data/final_data_quarter_inner_join.csv')
dim(inner_data)
## [1] 140 24
head(inner_data)
## X Quarter Country LOCATION INDICATOR SUBJECT MEASURE FREQUENCY TIME
## 1 1 Q1.2020 Australia AUS HUR TOT PC_LF M 2020-04
## 2 2 Q1.2020 Austria AUT HUR TOT PC_LF M 2020-04
## 3 3 Q1.2020 Belgium BEL HUR TOT PC_LF M 2020-04
## 4 4 Q1.2020 Canada CAN HUR TOT PC_LF M 2020-04
## 5 5 Q1.2020 Chile CHL HUR TOT PC_LF M 2020-04
## 6 6 Q1.2020 Colombia COL HUR TOT PC_LF M 2020-04
## Value Flag.Codes Date_reported Country_code WHO_region New_cases
## 1 6.353878 NA 4/3/2020 AU WPRO 374
## 2 4.900000 NA 4/3/2020 AT EURO 418
## 3 4.900000 NA 4/3/2020 BE EURO 1478
## 4 13.100000 NA 4/3/2020 CA AMRO 1109
## 5 10.885740 NA 4/3/2020 CL AMRO 373
## 6 20.132490 NA 4/3/2020 CO AMRO 159
## Cumulative_cases New_deaths Cumulative_deaths Population New_cases_pc
## 1 5350 5 26 24.992860 1.49643e-05
## 2 11129 12 158 8.837707 4.72973e-05
## 3 20065 219 1828 11.403740 1.29607e-04
## 4 10114 22 127 37.058856 2.99254e-05
## 5 3404 2 18 18.751405 1.98918e-05
## 6 1065 1 17 49.834240 3.19058e-06
## Cumulative_cases_pc New_deaths_pc Cumulative_deaths_pc GDP
## 1 0.0002140610 2.00057e-07 1.04030e-06 1,233,976
## 2 0.0012592630 1.35782e-06 1.78779e-05 454,026
## 3 0.0017595100 1.92042e-05 1.60298e-04 540,442
## 4 0.0002729170 5.93650e-07 3.42698e-06 1,708,880
## 5 0.0001815330 1.06659e-07 9.59928e-07 442,744
## 6 0.0000213708 2.00665e-08 3.41131e-07 677,975
summary(inner_data)
## X Quarter Country LOCATION
## Min. : 1.00 Length:140 Length:140 Length:140
## 1st Qu.: 35.75 Class :character Class :character Class :character
## Median : 70.50 Mode :character Mode :character Mode :character
## Mean : 70.50
## 3rd Qu.:105.25
## Max. :140.00
## INDICATOR SUBJECT MEASURE FREQUENCY
## Length:140 Length:140 Length:140 Length:140
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## TIME Value Flag.Codes Date_reported
## Length:140 Min. : 2.000 Mode:logical Length:140
## Class :character 1st Qu.: 4.447 NA's:140 Class :character
## Mode :character Median : 6.000 Mode :character
## Mean : 7.090
## 3rd Qu.: 8.300
## Max. :20.132
## Country_code WHO_region New_cases Cumulative_cases
## Length:140 Length:140 Min. : 0.0 Min. : 0
## Class :character Class :character 1st Qu.: 0.0 1st Qu.: 58
## Mode :character Mode :character Median : 118.0 Median : 6263
## Mean : 1921.7 Mean : 141820
## 3rd Qu.: 815.8 3rd Qu.: 63867
## Max. :54271.0 Max. :7206769
## New_deaths Cumulative_deaths Population New_cases_pc
## Min. : -5.00 Min. : 0 Min. : 0.3527 Min. :0.000e+00
## 1st Qu.: 0.00 1st Qu.: 0 1st Qu.: 5.4468 1st Qu.:0.000e+00
## Median : 1.00 Median : 126 Median : 10.7259 Median :1.068e-05
## Mean : 61.91 Mean : 6658 Mean : 38.2401 Mean :5.042e-05
## 3rd Qu.: 15.00 3rd Qu.: 1867 3rd Qu.: 51.6353 3rd Qu.:7.408e-05
## Max. :947.00 Max. :206558 Max. :327.1674 Max. :8.712e-04
## Cumulative_cases_pc New_deaths_pc Cumulative_deaths_pc
## Min. :0.000e+00 Min. :-1.029e-06 Min. :0.000e+00
## 1st Qu.:8.246e-06 1st Qu.: 0.000e+00 1st Qu.:0.000e+00
## Median :7.907e-04 Median : 1.076e-07 Median :1.881e-05
## Mean :2.809e-03 Mean : 1.250e-06 Mean :1.202e-04
## 3rd Qu.:3.177e-03 3rd Qu.: 9.174e-07 3rd Qu.:1.096e-04
## Max. :2.876e-02 Max. : 1.920e-05 Max. :8.802e-04
## GDP
## Length:140
## Class :character
## Mode :character
##
##
##
inner_data$Date_reported = as.Date(inner_data$Date_reported, "%m/%d/%Y")
inner_data$Date_reported = format(inner_data$Date_reported, "%Y-%m-%d")
inner_data$GDP = as.numeric(gsub(",", ".", gsub("\\.", "", inner_data$GDP)))
## Warning: NAs introduced by coercion
inner_data[is.na(inner_data)] = 0
inner_data
## X Quarter Country LOCATION INDICATOR SUBJECT MEASURE
## 1 1 Q1.2020 Australia AUS HUR TOT PC_LF
## 2 2 Q1.2020 Austria AUT HUR TOT PC_LF
## 3 3 Q1.2020 Belgium BEL HUR TOT PC_LF
## 4 4 Q1.2020 Canada CAN HUR TOT PC_LF
## 5 5 Q1.2020 Chile CHL HUR TOT PC_LF
## 6 6 Q1.2020 Colombia COL HUR TOT PC_LF
## 7 7 Q1.2020 Czechia CZE HUR TOT PC_LF
## 8 8 Q1.2020 Denmark DNK HUR TOT PC_LF
## 9 9 Q1.2020 Estonia EST HUR TOT PC_LF
## 10 10 Q1.2020 Finland FIN HUR TOT PC_LF
## 11 11 Q1.2020 France FRA HUR TOT PC_LF
## 12 12 Q1.2020 Germany DEU HUR TOT PC_LF
## 13 13 Q1.2020 Greece GRC HUR TOT PC_LF
## 14 14 Q1.2020 Hungary HUN HUR TOT PC_LF
## 15 15 Q1.2020 Iceland ISL HUR TOT PC_LF
## 16 16 Q1.2020 Ireland IRL HUR TOT PC_LF
## 17 17 Q1.2020 Israel ISR HUR TOT PC_LF
## 18 18 Q1.2020 Italy ITA HUR TOT PC_LF
## 19 19 Q1.2020 Japan JPN HUR TOT PC_LF
## 20 20 Q1.2020 Latvia LVA HUR TOT PC_LF
## 21 21 Q1.2020 Liechtenstein LTU HUR TOT PC_LF
## 22 22 Q1.2020 Luxembourg LUX HUR TOT PC_LF
## 23 23 Q1.2020 Mexico MEX HUR TOT PC_LF
## 24 24 Q1.2020 Netherlands NLD HUR TOT PC_LF
## 25 25 Q1.2020 Norway NOR HUR TOT PC_LF
## 26 26 Q1.2020 Poland POL HUR TOT PC_LF
## 27 27 Q1.2020 Portugal PRT HUR TOT PC_LF
## 28 28 Q1.2020 Republic of Korea KOR HUR TOT PC_LF
## 29 29 Q1.2020 Slovakia SVK HUR TOT PC_LF
## 30 30 Q1.2020 Slovenia SVN HUR TOT PC_LF
## 31 31 Q1.2020 Spain ESP HUR TOT PC_LF
## 32 32 Q1.2020 Sweden SWE HUR TOT PC_LF
## 33 33 Q1.2020 The United Kingdom GBR HUR TOT PC_LF
## 34 34 Q1.2020 Turkey TUR HUR TOT PC_LF
## 35 35 Q1.2020 United States of America USA HUR TOT PC_LF
## 36 36 Q2.2020 Australia AUS HUR TOT PC_LF
## 37 37 Q2.2020 Austria AUT HUR TOT PC_LF
## 38 38 Q2.2020 Belgium BEL HUR TOT PC_LF
## 39 39 Q2.2020 Canada CAN HUR TOT PC_LF
## 40 40 Q2.2020 Chile CHL HUR TOT PC_LF
## 41 41 Q2.2020 Colombia COL HUR TOT PC_LF
## 42 42 Q2.2020 Czechia CZE HUR TOT PC_LF
## 43 43 Q2.2020 Denmark DNK HUR TOT PC_LF
## 44 44 Q2.2020 Estonia EST HUR TOT PC_LF
## 45 45 Q2.2020 Finland FIN HUR TOT PC_LF
## 46 46 Q2.2020 France FRA HUR TOT PC_LF
## 47 47 Q2.2020 Germany DEU HUR TOT PC_LF
## 48 48 Q2.2020 Greece GRC HUR TOT PC_LF
## 49 49 Q2.2020 Hungary HUN HUR TOT PC_LF
## 50 50 Q2.2020 Iceland ISL HUR TOT PC_LF
## 51 51 Q2.2020 Ireland IRL HUR TOT PC_LF
## 52 52 Q2.2020 Israel ISR HUR TOT PC_LF
## 53 53 Q2.2020 Italy ITA HUR TOT PC_LF
## 54 54 Q2.2020 Japan JPN HUR TOT PC_LF
## 55 55 Q2.2020 Latvia LVA HUR TOT PC_LF
## 56 56 Q2.2020 Liechtenstein LTU HUR TOT PC_LF
## 57 57 Q2.2020 Luxembourg LUX HUR TOT PC_LF
## 58 58 Q2.2020 Mexico MEX HUR TOT PC_LF
## 59 59 Q2.2020 Netherlands NLD HUR TOT PC_LF
## 60 60 Q2.2020 Norway NOR HUR TOT PC_LF
## 61 61 Q2.2020 Poland POL HUR TOT PC_LF
## 62 62 Q2.2020 Portugal PRT HUR TOT PC_LF
## 63 63 Q2.2020 Republic of Korea KOR HUR TOT PC_LF
## 64 64 Q2.2020 Slovakia SVK HUR TOT PC_LF
## 65 65 Q2.2020 Slovenia SVN HUR TOT PC_LF
## 66 66 Q2.2020 Spain ESP HUR TOT PC_LF
## 67 67 Q2.2020 Sweden SWE HUR TOT PC_LF
## 68 68 Q2.2020 The United Kingdom GBR HUR TOT PC_LF
## 69 69 Q2.2020 Turkey TUR HUR TOT PC_LF
## 70 70 Q2.2020 United States of America USA HUR TOT PC_LF
## 71 71 Q3.2020 Australia AUS HUR TOT PC_LF
## 72 72 Q3.2020 Austria AUT HUR TOT PC_LF
## 73 73 Q3.2020 Belgium BEL HUR TOT PC_LF
## 74 74 Q3.2020 Canada CAN HUR TOT PC_LF
## 75 75 Q3.2020 Chile CHL HUR TOT PC_LF
## 76 76 Q3.2020 Colombia COL HUR TOT PC_LF
## 77 77 Q3.2020 Czechia CZE HUR TOT PC_LF
## 78 78 Q3.2020 Denmark DNK HUR TOT PC_LF
## 79 79 Q3.2020 Estonia EST HUR TOT PC_LF
## 80 80 Q3.2020 Finland FIN HUR TOT PC_LF
## 81 81 Q3.2020 France FRA HUR TOT PC_LF
## 82 82 Q3.2020 Germany DEU HUR TOT PC_LF
## 83 83 Q3.2020 Greece GRC HUR TOT PC_LF
## 84 84 Q3.2020 Hungary HUN HUR TOT PC_LF
## 85 85 Q3.2020 Iceland ISL HUR TOT PC_LF
## 86 86 Q3.2020 Ireland IRL HUR TOT PC_LF
## 87 87 Q3.2020 Israel ISR HUR TOT PC_LF
## 88 88 Q3.2020 Italy ITA HUR TOT PC_LF
## 89 89 Q3.2020 Japan JPN HUR TOT PC_LF
## 90 90 Q3.2020 Latvia LVA HUR TOT PC_LF
## 91 91 Q3.2020 Liechtenstein LTU HUR TOT PC_LF
## 92 92 Q3.2020 Luxembourg LUX HUR TOT PC_LF
## 93 93 Q3.2020 Mexico MEX HUR TOT PC_LF
## 94 94 Q3.2020 Netherlands NLD HUR TOT PC_LF
## 95 95 Q3.2020 Norway NOR HUR TOT PC_LF
## 96 96 Q3.2020 Poland POL HUR TOT PC_LF
## 97 97 Q3.2020 Portugal PRT HUR TOT PC_LF
## 98 98 Q3.2020 Republic of Korea KOR HUR TOT PC_LF
## 99 99 Q3.2020 Slovakia SVK HUR TOT PC_LF
## 100 100 Q3.2020 Slovenia SVN HUR TOT PC_LF
## 101 101 Q3.2020 Spain ESP HUR TOT PC_LF
## 102 102 Q3.2020 Sweden SWE HUR TOT PC_LF
## 103 103 Q3.2020 The United Kingdom GBR HUR TOT PC_LF
## 104 104 Q3.2020 Turkey TUR HUR TOT PC_LF
## 105 105 Q3.2020 United States of America USA HUR TOT PC_LF
## 106 106 Q4.2019 Australia AUS HUR TOT PC_LF
## 107 107 Q4.2019 Austria AUT HUR TOT PC_LF
## 108 108 Q4.2019 Belgium BEL HUR TOT PC_LF
## 109 109 Q4.2019 Canada CAN HUR TOT PC_LF
## 110 110 Q4.2019 Chile CHL HUR TOT PC_LF
## 111 111 Q4.2019 Colombia COL HUR TOT PC_LF
## 112 112 Q4.2019 Czechia CZE HUR TOT PC_LF
## 113 113 Q4.2019 Denmark DNK HUR TOT PC_LF
## 114 114 Q4.2019 Estonia EST HUR TOT PC_LF
## 115 115 Q4.2019 Finland FIN HUR TOT PC_LF
## 116 116 Q4.2019 France FRA HUR TOT PC_LF
## 117 117 Q4.2019 Germany DEU HUR TOT PC_LF
## 118 118 Q4.2019 Greece GRC HUR TOT PC_LF
## 119 119 Q4.2019 Hungary HUN HUR TOT PC_LF
## 120 120 Q4.2019 Iceland ISL HUR TOT PC_LF
## 121 121 Q4.2019 Ireland IRL HUR TOT PC_LF
## 122 122 Q4.2019 Israel ISR HUR TOT PC_LF
## 123 123 Q4.2019 Italy ITA HUR TOT PC_LF
## 124 124 Q4.2019 Japan JPN HUR TOT PC_LF
## 125 125 Q4.2019 Latvia LVA HUR TOT PC_LF
## 126 126 Q4.2019 Liechtenstein LTU HUR TOT PC_LF
## 127 127 Q4.2019 Luxembourg LUX HUR TOT PC_LF
## 128 128 Q4.2019 Mexico MEX HUR TOT PC_LF
## 129 129 Q4.2019 Netherlands NLD HUR TOT PC_LF
## 130 130 Q4.2019 Norway NOR HUR TOT PC_LF
## 131 131 Q4.2019 Poland POL HUR TOT PC_LF
## 132 132 Q4.2019 Portugal PRT HUR TOT PC_LF
## 133 133 Q4.2019 Republic of Korea KOR HUR TOT PC_LF
## 134 134 Q4.2019 Slovakia SVK HUR TOT PC_LF
## 135 135 Q4.2019 Slovenia SVN HUR TOT PC_LF
## 136 136 Q4.2019 Spain ESP HUR TOT PC_LF
## 137 137 Q4.2019 Sweden SWE HUR TOT PC_LF
## 138 138 Q4.2019 The United Kingdom GBR HUR TOT PC_LF
## 139 139 Q4.2019 Turkey TUR HUR TOT PC_LF
## 140 140 Q4.2019 United States of America USA HUR TOT PC_LF
## FREQUENCY TIME Value Flag.Codes Date_reported Country_code
## 1 M 2020-04 6.353878 0 2020-04-03 AU
## 2 M 2020-04 4.900000 0 2020-04-03 AT
## 3 M 2020-04 4.900000 0 2020-04-03 BE
## 4 M 2020-04 13.100000 0 2020-04-03 CA
## 5 M 2020-04 10.885740 0 2020-04-03 CL
## 6 M 2020-04 20.132490 0 2020-04-03 CO
## 7 M 2020-04 2.200000 0 2020-04-03 CZ
## 8 M 2020-04 4.900000 0 2020-04-03 DK
## 9 M 2020-04 6.000000 0 2020-04-03 EE
## 10 M 2020-04 7.300000 0 2020-04-03 FI
## 11 M 2020-04 7.300000 0 2020-04-03 FR
## 12 M 2020-04 4.000000 0 2020-04-03 DE
## 13 M 2020-04 16.200000 0 2020-04-03 GR
## 14 M 2020-04 4.100000 0 2020-04-03 HU
## 15 M 2020-04 4.800000 0 2020-04-03 IS
## 16 M 2020-04 4.700000 0 2020-04-03 IE
## 17 M 2020-04 3.670104 0 2020-04-03 IL
## 18 M 2020-04 7.400000 0 2020-04-03 IT
## 19 M 2020-04 2.600000 0 2020-04-03 JP
## 20 M 2020-04 8.200000 0 2020-04-03 LV
## 21 M 2020-04 7.800000 0 2020-04-03 LI
## 22 M 2020-04 7.400000 0 2020-04-03 LU
## 23 M 2020-04 4.801267 0 2020-04-03 MX
## 24 M 2020-04 3.400000 0 2020-04-03 NL
## 25 M 2020-04 4.100000 0 2020-04-03 NO
## 26 M 2020-04 3.100000 0 2020-04-03 PL
## 27 M 2020-04 6.300000 0 2020-04-03 PT
## 28 M 2020-04 3.800000 0 2020-04-03 KR
## 29 M 2020-04 6.600000 0 2020-04-03 SK
## 30 M 2020-04 5.300000 0 2020-04-03 SI
## 31 M 2020-04 15.200000 0 2020-04-03 ES
## 32 M 2020-04 7.900000 0 2020-04-03 SE
## 33 M 2020-04 4.054801 0 2020-04-03 GB
## 34 M 2020-04 13.600000 0 2020-04-03 TR
## 35 M 2020-04 14.800000 0 2020-04-03 US
## 36 M 2020-07 7.480891 0 2020-07-03 AU
## 37 M 2020-07 5.800000 0 2020-07-03 AT
## 38 M 2020-07 5.900000 0 2020-07-03 BE
## 39 M 2020-07 10.900000 0 2020-07-03 CA
## 40 M 2020-07 12.263920 0 2020-07-03 CL
## 41 M 2020-07 19.438160 0 2020-07-03 CO
## 42 M 2020-07 2.700000 0 2020-07-03 CZ
## 43 M 2020-07 6.300000 0 2020-07-03 DK
## 44 M 2020-07 7.800000 0 2020-07-03 EE
## 45 M 2020-07 8.600000 0 2020-07-03 FI
## 46 M 2020-07 9.400000 0 2020-07-03 FR
## 47 M 2020-07 4.400000 0 2020-07-03 DE
## 48 M 2020-07 16.700000 0 2020-07-03 GR
## 49 M 2020-07 4.600000 0 2020-07-03 HU
## 50 M 2020-07 5.300000 0 2020-07-03 IS
## 51 M 2020-07 6.200000 0 2020-07-03 IE
## 52 M 2020-07 4.661653 0 2020-07-03 IL
## 53 M 2020-07 9.700000 0 2020-07-03 IT
## 54 M 2020-07 2.900000 0 2020-07-03 JP
## 55 M 2020-07 8.800000 0 2020-07-03 LV
## 56 M 2020-07 9.600000 0 2020-07-03 LI
## 57 M 2020-07 7.200000 0 2020-07-03 LU
## 58 M 2020-07 5.120639 0 2020-07-03 MX
## 59 M 2020-07 4.500000 0 2020-07-03 NL
## 60 M 2020-07 5.200000 0 2020-07-03 NO
## 61 M 2020-07 3.400000 0 2020-07-03 PL
## 62 M 2020-07 7.900000 0 2020-07-03 PT
## 63 M 2020-07 4.100000 0 2020-07-03 KR
## 64 M 2020-07 7.100000 0 2020-07-03 SK
## 65 M 2020-07 5.200000 0 2020-07-03 SI
## 66 M 2020-07 16.400000 0 2020-07-03 ES
## 67 M 2020-07 9.100000 0 2020-07-03 SE
## 68 M 2020-07 4.462407 0 2020-07-03 GB
## 69 M 2020-07 13.800000 0 2020-07-03 TR
## 70 M 2020-07 10.200000 0 2020-07-03 US
## 71 M 2020-10 6.987514 0 2020-10-03 AU
## 72 M 2020-10 5.400000 0 2020-10-03 AT
## 73 M 2020-10 6.300000 0 2020-10-03 BE
## 74 M 2020-10 9.000000 0 2020-10-03 CA
## 75 M 2020-10 11.175280 0 2020-10-03 CL
## 76 M 2020-10 16.053990 0 2020-10-03 CO
## 77 M 2020-10 2.800000 0 2020-10-03 CZ
## 78 M 2020-10 5.900000 0 2020-10-03 DK
## 79 M 2020-10 8.100000 0 2020-10-03 EE
## 80 M 2020-10 8.200000 0 2020-10-03 FI
## 81 M 2020-10 8.600000 0 2020-10-03 FR
## 82 M 2020-10 4.500000 0 2020-10-03 DE
## 83 M 2020-10 16.700000 0 2020-10-03 GR
## 84 M 2020-10 4.500000 0 2020-10-03 HU
## 85 M 2020-10 5.900000 0 2020-10-03 IS
## 86 M 2020-10 7.100000 0 2020-10-03 IE
## 87 M 2020-10 4.688548 0 2020-10-03 IL
## 88 M 2020-10 9.500000 0 2020-10-03 IT
## 89 M 2020-10 3.100000 0 2020-10-03 JP
## 90 M 2020-10 8.100000 0 2020-10-03 LV
## 91 M 2020-10 10.400000 0 2020-10-03 LI
## 92 M 2020-10 6.500000 0 2020-10-03 LU
## 93 M 2020-10 4.602410 0 2020-10-03 MX
## 94 M 2020-10 4.300000 0 2020-10-03 NL
## 95 M 2020-10 5.200000 0 2020-10-03 NO
## 96 M 2020-10 3.400000 0 2020-10-03 PL
## 97 M 2020-10 7.500000 0 2020-10-03 PT
## 98 M 2020-10 4.200000 0 2020-10-03 KR
## 99 M 2020-10 7.100000 0 2020-10-03 SK
## 100 M 2020-10 4.900000 0 2020-10-03 SI
## 101 M 2020-10 16.300000 0 2020-10-03 ES
## 102 M 2020-10 8.600000 0 2020-10-03 SE
## 103 M 2020-10 5.038247 0 2020-10-03 GB
## 104 M 2020-10 12.900000 0 2020-10-03 TR
## 105 M 2020-10 6.900000 0 2020-10-03 US
## 106 M 2020-01 5.264596 0 2020-01-03 AU
## 107 M 2020-01 4.400000 0 2020-01-03 AT
## 108 M 2020-01 5.100000 0 2020-01-03 BE
## 109 M 2020-01 5.600000 0 2020-01-03 CA
## 110 M 2020-01 8.117333 0 2020-01-03 CL
## 111 M 2020-01 10.596480 0 2020-01-03 CO
## 112 M 2020-01 2.000000 0 2020-01-03 CZ
## 113 M 2020-01 5.000000 0 2020-01-03 DK
## 114 M 2020-01 4.700000 0 2020-01-03 EE
## 115 M 2020-01 6.900000 0 2020-01-03 FI
## 116 M 2020-01 7.700000 0 2020-01-03 FR
## 117 M 2020-01 3.400000 0 2020-01-03 DE
## 118 M 2020-01 16.400000 0 2020-01-03 GR
## 119 M 2020-01 3.400000 0 2020-01-03 HU
## 120 M 2020-01 4.100000 0 2020-01-03 IS
## 121 M 2020-01 4.900000 0 2020-01-03 IE
## 122 M 2020-01 3.644195 0 2020-01-03 IL
## 123 M 2020-01 9.600000 0 2020-01-03 IT
## 124 M 2020-01 2.400000 0 2020-01-03 JP
## 125 M 2020-01 7.000000 0 2020-01-03 LV
## 126 M 2020-01 6.100000 0 2020-01-03 LI
## 127 M 2020-01 5.700000 0 2020-01-03 LU
## 128 M 2020-01 3.656332 0 2020-01-03 MX
## 129 M 2020-01 3.000000 0 2020-01-03 NL
## 130 M 2020-01 3.700000 0 2020-01-03 NO
## 131 M 2020-01 3.000000 0 2020-01-03 PL
## 132 M 2020-01 6.800000 0 2020-01-03 PT
## 133 M 2020-01 3.900000 0 2020-01-03 KR
## 134 M 2020-01 6.000000 0 2020-01-03 SK
## 135 M 2020-01 4.100000 0 2020-01-03 SI
## 136 M 2020-01 13.800000 0 2020-01-03 ES
## 137 M 2020-01 7.200000 0 2020-01-03 SE
## 138 M 2020-01 3.961213 0 2020-01-03 GB
## 139 M 2020-01 12.600000 0 2020-01-03 TR
## 140 M 2020-01 3.500000 0 2020-01-03 US
## WHO_region New_cases Cumulative_cases New_deaths Cumulative_deaths
## 1 WPRO 374 5350 5 26
## 2 EURO 418 11129 12 158
## 3 EURO 1478 20065 219 1828
## 4 AMRO 1109 10114 22 127
## 5 AMRO 373 3404 2 18
## 6 AMRO 159 1065 1 17
## 7 EURO 269 3858 5 44
## 8 EURO 279 3386 19 123
## 9 EURO 79 858 6 11
## 10 EURO 72 1518 2 19
## 11 EURO 2066 58327 471 4490
## 12 EURO 6174 79696 145 1017
## 13 EURO 139 1514 3 53
## 14 EURO 38 623 5 26
## 15 EURO 99 1319 2 4
## 16 EURO 402 3849 13 98
## 17 EURO 696 6421 8 29
## 18 EURO 4668 115242 760 13917
## 19 WPRO 233 2617 8 65
## 20 EURO 12 458 0 0
## 21 EURO 1 77 0 0
## 22 EURO 168 2487 1 30
## 23 AMRO 163 1378 8 37
## 24 EURO 1083 14543 155 1292
## 25 EURO 270 4935 10 42
## 26 EURO 392 2946 14 57
## 27 EURO 783 9034 22 209
## 28 WPRO 86 10062 5 174
## 29 EURO 37 400 0 0
## 30 EURO 55 897 1 20
## 31 EURO 7058 131421 895 11285
## 32 EURO 486 5320 53 385
## 33 EURO 4913 43385 657 3782
## 34 EURO 2456 18135 79 356
## 35 AMRO 26298 213600 947 4793
## 36 WPRO 81 8001 0 104
## 37 EURO 138 17952 0 705
## 38 EURO 93 62306 5 9631
## 39 AMRO 0 104204 0 8591
## 40 AMRO 2498 284541 167 5920
## 41 AMRO 4163 102009 136 3470
## 42 EURO 132 12178 2 351
## 43 EURO 21 12815 0 606
## 44 EURO 1 1990 0 63
## 45 EURO 5 7241 0 328
## 46 EURO 480 158286 14 29791
## 47 EURO 446 195674 9 9003
## 48 EURO 26 3458 0 192
## 49 EURO 9 4166 1 587
## 50 EURO 5 1830 0 10
## 51 EURO 12 25489 0 1738
## 52 EURO 972 26421 3 330
## 53 EURO 201 240961 30 34818
## 54 WPRO 194 19068 1 976
## 55 EURO 1 1122 0 30
## 56 EURO 0 84 0 1
## 57 EURO 50 4395 0 110
## 58 AMRO 5681 231770 741 28510
## 59 EURO 75 50196 3 6092
## 60 EURO 8 8895 0 251
## 61 EURO 371 35146 15 1492
## 62 EURO 328 42782 8 1587
## 63 WPRO 61 12965 0 282
## 64 EURO 20 1687 0 28
## 65 EURO 21 1633 0 114
## 66 EURO 521 260017 10 29765
## 67 EURO 685 68551 15 5529
## 68 EURO 651 285543 41 40532
## 69 EURO 1186 202284 17 5167
## 70 AMRO 54271 2671220 725 127858
## 71 WPRO 17 27113 2 890
## 72 EURO 872 47189 1 803
## 73 EURO 3721 132825 11 10037
## 74 AMRO 1777 160535 22 9319
## 75 AMRO 1840 466590 45 12867
## 76 AMRO 5660 835339 198 26196
## 77 EURO 3796 78051 21 699
## 78 EURO 536 28932 1 652
## 79 EURO 57 3507 1 66
## 80 EURO 101 10204 1 345
## 81 EURO 11543 563796 118 31926
## 82 EURO 2563 296958 19 9527
## 83 EURO 460 19346 5 398
## 84 EURO 1086 29717 14 812
## 85 EURO 40 2809 0 10
## 86 EURO 466 37063 -5 1801
## 87 EURO 7730 255149 46 1651
## 88 EURO 2499 319908 23 35941
## 89 WPRO 553 84768 12 1590
## 90 EURO 77 1945 1 38
## 91 EURO 3 125 0 1
## 92 EURO 114 8709 0 125
## 93 AMRO 5099 748315 432 78078
## 94 EURO 3804 127659 9 6427
## 95 EURO 122 14149 1 275
## 96 EURO 2292 95773 27 2570
## 97 EURO 888 77284 6 1983
## 98 WPRO 75 24027 4 420
## 99 EURO 797 10938 0 48
## 100 EURO 239 6105 2 159
## 101 EURO 11354 842863 131 34269
## 102 EURO 633 94473 1 5884
## 103 EURO 6968 467150 66 42268
## 104 EURO 8172 772422 63 8325
## 105 AMRO 46293 7206769 892 206558
## 106 WPRO 0 0 0 0
## 107 EURO 0 0 0 0
## 108 EURO 0 0 0 0
## 109 AMRO 0 0 0 0
## 110 AMRO 0 0 0 0
## 111 AMRO 0 0 0 0
## 112 EURO 0 0 0 0
## 113 EURO 0 0 0 0
## 114 EURO 0 0 0 0
## 115 EURO 0 0 0 0
## 116 EURO 0 0 0 0
## 117 EURO 0 0 0 0
## 118 EURO 0 0 0 0
## 119 EURO 0 0 0 0
## 120 EURO 0 0 0 0
## 121 EURO 0 0 0 0
## 122 EURO 0 0 0 0
## 123 EURO 0 0 0 0
## 124 WPRO 0 0 0 0
## 125 EURO 0 0 0 0
## 126 EURO 0 0 0 0
## 127 EURO 0 0 0 0
## 128 AMRO 0 0 0 0
## 129 EURO 0 0 0 0
## 130 EURO 0 0 0 0
## 131 EURO 0 0 0 0
## 132 EURO 0 0 0 0
## 133 WPRO 0 0 0 0
## 134 EURO 0 0 0 0
## 135 EURO 0 0 0 0
## 136 EURO 0 0 0 0
## 137 EURO 0 0 0 0
## 138 EURO 0 0 0 0
## 139 EURO 0 0 0 0
## 140 AMRO 0 0 0 0
## Population New_cases_pc Cumulative_cases_pc New_deaths_pc
## 1 24.992860 1.49643e-05 0.0002140610 2.00057e-07
## 2 8.837707 4.72973e-05 0.0012592630 1.35782e-06
## 3 11.403740 1.29607e-04 0.0017595100 1.92042e-05
## 4 37.058856 2.99254e-05 0.0002729170 5.93650e-07
## 5 18.751405 1.98918e-05 0.0001815330 1.06659e-07
## 6 49.834240 3.19058e-06 0.0000213708 2.00665e-08
## 7 10.626430 2.53142e-05 0.0003630570 4.70525e-07
## 8 5.789957 4.81869e-05 0.0005848060 3.28154e-06
## 9 1.321977 5.97590e-05 0.0006490280 4.53866e-06
## 10 5.515525 1.30541e-05 0.0002752230 3.62613e-07
## 11 66.941698 3.08627e-05 0.0008713100 7.03597e-06
## 12 82.914191 7.44625e-05 0.0009611860 1.74880e-06
## 13 10.725886 1.29593e-05 0.0001411540 2.79697e-07
## 14 9.767600 3.89041e-06 0.0000637823 5.11896e-07
## 15 0.352722 2.80674e-04 0.0037394890 5.67019e-06
## 16 4.857015 8.27669e-05 0.0007924620 2.67654e-06
## 17 8.872943 7.84407e-05 0.0007236610 9.01617e-07
## 18 60.421797 7.72569e-05 0.0019072920 1.25782e-05
## 19 126.443180 1.84272e-06 0.0000206970 6.32695e-08
## 20 1.927170 6.22675e-06 0.0002376540 0.00000e+00
## 21 2.801541 3.56946e-07 0.0000274849 0.00000e+00
## 22 0.607950 2.76339e-04 0.0040907970 1.64487e-06
## 23 125.327797 1.30059e-06 0.0000109952 6.38326e-08
## 24 17.231622 6.28496e-05 0.0008439720 8.99509e-06
## 25 5.311916 5.08291e-05 0.0009290430 1.88256e-06
## 26 38.413139 1.02048e-05 0.0000766925 3.64459e-07
## 27 10.283822 7.61390e-05 0.0008784670 2.13928e-06
## 28 51.635256 1.66553e-06 0.0001948670 9.68331e-08
## 29 5.446771 6.79302e-06 0.0000734380 0.00000e+00
## 30 2.070050 2.65694e-05 0.0004333230 4.83080e-07
## 31 46.733038 1.51028e-04 0.0028121650 1.91513e-05
## 32 10.175214 4.77631e-05 0.0005228390 5.20874e-06
## 33 66.435550 7.39514e-05 0.0006530390 9.88928e-06
## 34 81.407211 3.01693e-05 0.0002227690 9.70430e-07
## 35 327.167434 8.03809e-05 0.0006528770 2.89454e-06
## 36 24.992860 3.24093e-06 0.0003201310 0.00000e+00
## 37 8.837707 1.56149e-05 0.0020312960 0.00000e+00
## 38 11.403740 8.15522e-06 0.0054636460 4.38453e-07
## 39 37.058856 0.00000e+00 0.0028118520 0.00000e+00
## 40 18.751405 1.33217e-04 0.0151743830 8.90600e-06
## 41 49.834240 8.35369e-05 0.0020469660 2.72905e-06
## 42 10.626430 1.24219e-05 0.0011460100 1.88210e-07
## 43 5.789957 3.62697e-06 0.0022133150 0.00000e+00
## 44 1.321977 7.56443e-07 0.0015053210 0.00000e+00
## 45 5.515525 9.06532e-07 0.0013128400 0.00000e+00
## 46 66.941698 7.17042e-06 0.0023645350 2.09137e-07
## 47 82.914191 5.37906e-06 0.0023599580 1.08546e-07
## 48 10.725886 2.42404e-06 0.0003223980 0.00000e+00
## 49 9.767600 9.21414e-07 0.0004265120 1.02379e-07
## 50 0.352722 1.41755e-05 0.0051882220 0.00000e+00
## 51 4.857015 2.47065e-06 0.0052478730 0.00000e+00
## 52 8.872943 1.09547e-04 0.0029777040 3.38107e-07
## 53 60.421797 3.32661e-06 0.0039879810 4.96510e-07
## 54 126.443180 1.53429e-06 0.0001508030 7.90869e-09
## 55 1.927170 5.18896e-07 0.0005822010 0.00000e+00
## 56 2.801541 0.00000e+00 0.0000299835 0.00000e+00
## 57 0.607950 8.22436e-05 0.0072292130 0.00000e+00
## 58 125.327797 4.53291e-05 0.0018493100 5.91250e-06
## 59 17.231622 4.35246e-06 0.0029130170 1.74099e-07
## 60 5.311916 1.50605e-06 0.0016745370 0.00000e+00
## 61 38.413139 9.65815e-06 0.0009149470 3.90491e-07
## 62 10.283822 3.18948e-05 0.0041601260 7.77921e-07
## 63 51.635256 1.18136e-06 0.0002510880 0.00000e+00
## 64 5.446771 3.67190e-06 0.0003097250 0.00000e+00
## 65 2.070050 1.01447e-05 0.0007888700 0.00000e+00
## 66 46.733038 1.11484e-05 0.0055638800 2.13981e-07
## 67 10.175214 6.73205e-05 0.0067370570 1.47417e-06
## 68 66.435550 9.79897e-06 0.0042980450 6.17139e-07
## 69 81.407211 1.45687e-05 0.0024848410 2.08827e-07
## 70 327.167434 1.65881e-04 0.0081646880 2.21599e-06
## 71 24.992860 6.80194e-07 0.0010848300 8.00229e-08
## 72 8.837707 9.86681e-05 0.0053395070 1.13152e-07
## 73 11.403740 3.26296e-04 0.0116474950 9.64596e-07
## 74 37.058856 4.79508e-05 0.0043318930 5.93650e-07
## 75 18.751405 9.81260e-05 0.0248829350 2.39982e-06
## 76 49.834240 1.13577e-04 0.0167623510 3.97317e-06
## 77 10.626430 3.57223e-04 0.0073449880 1.97620e-06
## 78 5.789957 9.25741e-05 0.0049969280 1.72713e-07
## 79 1.321977 4.31172e-05 0.0026528450 7.56443e-07
## 80 5.515525 1.83119e-05 0.0018500510 1.81306e-07
## 81 66.941698 1.72434e-04 0.0084221940 1.76273e-06
## 82 82.914191 3.09115e-05 0.0035815100 2.29153e-07
## 83 10.725886 4.28869e-05 0.0018036740 4.66162e-07
## 84 9.767600 1.11184e-04 0.0030424060 1.43331e-06
## 85 0.352722 1.13404e-04 0.0079637790 0.00000e+00
## 86 4.857015 9.59437e-05 0.0076308190 -1.02944e-06
## 87 8.872943 8.71188e-04 0.0287558480 5.18430e-06
## 88 60.421797 4.13592e-05 0.0052945790 3.80657e-07
## 89 126.443180 4.37351e-06 0.0006704040 9.49043e-08
## 90 1.927170 3.99550e-05 0.0010092520 5.18896e-07
## 91 2.801541 1.07084e-06 0.0000446183 0.00000e+00
## 92 0.607950 1.87515e-04 0.0143251910 0.00000e+00
## 93 125.327797 4.06853e-05 0.0059708620 3.44696e-06
## 94 17.231622 2.20757e-04 0.0074084150 5.22296e-07
## 95 5.311916 2.29672e-05 0.0026636340 1.88256e-07
## 96 38.413139 5.96671e-05 0.0024932350 7.02885e-07
## 97 10.283822 8.63492e-05 0.0075151050 5.83441e-07
## 98 51.635256 1.45250e-06 0.0004653220 7.74665e-08
## 99 5.446771 1.46325e-04 0.0020081620 0.00000e+00
## 100 2.070050 1.15456e-04 0.0029492040 9.66160e-07
## 101 46.733038 2.42954e-04 0.0180356990 2.80316e-06
## 102 10.175214 6.22100e-05 0.0092846200 9.82780e-08
## 103 66.435550 1.04884e-04 0.0070316270 9.93444e-07
## 104 81.407211 1.00384e-04 0.0094883730 7.73887e-07
## 105 327.167434 1.41496e-04 0.0220277700 2.72643e-06
## 106 24.992860 0.00000e+00 0.0000000000 0.00000e+00
## 107 8.837707 0.00000e+00 0.0000000000 0.00000e+00
## 108 11.403740 0.00000e+00 0.0000000000 0.00000e+00
## 109 37.058856 0.00000e+00 0.0000000000 0.00000e+00
## 110 18.751405 0.00000e+00 0.0000000000 0.00000e+00
## 111 49.834240 0.00000e+00 0.0000000000 0.00000e+00
## 112 10.626430 0.00000e+00 0.0000000000 0.00000e+00
## 113 5.789957 0.00000e+00 0.0000000000 0.00000e+00
## 114 1.321977 0.00000e+00 0.0000000000 0.00000e+00
## 115 5.515525 0.00000e+00 0.0000000000 0.00000e+00
## 116 66.941698 0.00000e+00 0.0000000000 0.00000e+00
## 117 82.914191 0.00000e+00 0.0000000000 0.00000e+00
## 118 10.725886 0.00000e+00 0.0000000000 0.00000e+00
## 119 9.767600 0.00000e+00 0.0000000000 0.00000e+00
## 120 0.352722 0.00000e+00 0.0000000000 0.00000e+00
## 121 4.857015 0.00000e+00 0.0000000000 0.00000e+00
## 122 8.872943 0.00000e+00 0.0000000000 0.00000e+00
## 123 60.421797 0.00000e+00 0.0000000000 0.00000e+00
## 124 126.443180 0.00000e+00 0.0000000000 0.00000e+00
## 125 1.927170 0.00000e+00 0.0000000000 0.00000e+00
## 126 2.801541 0.00000e+00 0.0000000000 0.00000e+00
## 127 0.607950 0.00000e+00 0.0000000000 0.00000e+00
## 128 125.327797 0.00000e+00 0.0000000000 0.00000e+00
## 129 17.231622 0.00000e+00 0.0000000000 0.00000e+00
## 130 5.311916 0.00000e+00 0.0000000000 0.00000e+00
## 131 38.413139 0.00000e+00 0.0000000000 0.00000e+00
## 132 10.283822 0.00000e+00 0.0000000000 0.00000e+00
## 133 51.635256 0.00000e+00 0.0000000000 0.00000e+00
## 134 5.446771 0.00000e+00 0.0000000000 0.00000e+00
## 135 2.070050 0.00000e+00 0.0000000000 0.00000e+00
## 136 46.733038 0.00000e+00 0.0000000000 0.00000e+00
## 137 10.175214 0.00000e+00 0.0000000000 0.00000e+00
## 138 66.435550 0.00000e+00 0.0000000000 0.00000e+00
## 139 81.407211 0.00000e+00 0.0000000000 0.00000e+00
## 140 327.167434 0.00000e+00 0.0000000000 0.00000e+00
## Cumulative_deaths_pc GDP
## 1 1.04030e-06 0.000
## 2 1.78779e-05 454.026
## 3 1.60298e-04 540.442
## 4 3.42698e-06 0.000
## 5 9.59928e-07 442.744
## 6 3.41131e-07 677.975
## 7 4.14062e-06 396.444
## 8 2.12437e-05 307.870
## 9 8.32087e-06 45.864
## 10 3.44482e-06 248.866
## 11 6.70733e-05 0.000
## 12 1.22657e-05 0.000
## 13 4.94132e-06 301.354
## 14 2.66186e-06 312.275
## 15 1.13404e-05 18.315
## 16 2.01770e-05 417.865
## 17 3.26836e-06 341.032
## 18 2.30331e-04 0.000
## 19 5.14065e-07 0.000
## 20 0.00000e+00 54.429
## 21 0.00000e+00 0.000
## 22 4.93462e-05 66.074
## 23 2.95226e-07 0.000
## 24 7.49784e-05 923.754
## 25 7.90675e-06 330.901
## 26 1.48387e-06 0.000
## 27 2.03232e-05 330.355
## 28 3.36979e-06 0.000
## 29 0.00000e+00 173.352
## 30 9.66160e-06 73.154
## 31 2.41478e-04 0.000
## 32 3.78370e-05 524.146
## 33 5.69274e-05 0.000
## 34 4.37308e-06 0.000
## 35 1.46500e-05 0.000
## 36 4.16119e-06 0.000
## 37 7.97718e-05 401.506
## 38 8.44547e-04 476.577
## 39 2.31820e-04 0.000
## 40 3.15710e-04 383.115
## 41 6.96308e-05 577.711
## 42 3.30308e-05 362.709
## 43 1.04664e-04 286.100
## 44 4.76559e-05 43.344
## 45 5.94685e-05 239.219
## 46 4.45029e-04 0.000
## 47 1.08582e-04 0.000
## 48 1.79006e-05 258.719
## 49 6.00966e-05 266.738
## 50 2.83509e-05 16.975
## 51 3.57833e-04 404.491
## 52 3.71917e-05 312.098
## 53 5.76249e-04 0.000
## 54 7.71888e-06 0.000
## 55 1.55669e-05 50.577
## 56 3.56946e-07 0.000
## 57 1.80936e-04 61.178
## 58 2.27483e-04 0.000
## 59 3.53536e-04 844.846
## 60 4.72523e-05 315.681
## 61 3.88409e-05 0.000
## 62 1.54320e-04 284.385
## 63 5.46138e-06 0.000
## 64 5.14066e-06 158.962
## 65 5.50711e-05 65.994
## 66 6.36916e-04 0.000
## 67 5.43379e-04 482.477
## 68 6.10095e-04 0.000
## 69 6.34710e-05 0.000
## 70 3.90803e-04 0.000
## 71 3.56102e-05 0.000
## 72 9.08607e-05 449.546
## 73 8.80150e-04 532.052
## 74 2.51465e-04 0.000
## 75 6.86189e-04 403.125
## 76 5.25663e-04 631.906
## 77 6.57794e-05 387.876
## 78 1.12609e-04 301.042
## 79 4.99252e-05 44.756
## 80 6.25507e-05 246.765
## 81 4.76922e-04 0.000
## 82 1.14902e-04 0.000
## 83 3.71065e-05 264.644
## 84 8.31320e-05 297.105
## 85 2.83509e-05 17.414
## 86 3.70804e-04 449.200
## 87 1.86071e-04 340.401
## 88 5.94835e-04 0.000
## 89 1.25748e-05 0.000
## 90 1.97180e-05 54.184
## 91 3.56946e-07 0.000
## 92 2.05609e-04 67.200
## 93 6.22990e-04 0.000
## 94 3.72977e-04 910.341
## 95 5.17704e-05 329.756
## 96 6.69042e-05 0.000
## 97 1.92827e-04 322.072
## 98 8.13398e-06 0.000
## 99 8.81256e-06 177.468
## 100 7.68097e-05 74.181
## 101 7.33293e-04 0.000
## 102 5.78268e-04 506.264
## 103 6.36226e-04 0.000
## 104 1.02264e-04 0.000
## 105 6.31353e-04 0.000
## 106 0.00000e+00 0.000
## 107 0.00000e+00 466.947
## 108 0.00000e+00 559.563
## 109 0.00000e+00 0.000
## 110 0.00000e+00 429.980
## 111 0.00000e+00 694.493
## 112 0.00000e+00 409.939
## 113 0.00000e+00 312.605
## 114 0.00000e+00 46.243
## 115 0.00000e+00 252.718
## 116 0.00000e+00 0.000
## 117 0.00000e+00 0.000
## 118 0.00000e+00 300.964
## 119 0.00000e+00 313.378
## 120 0.00000e+00 19.821
## 121 0.00000e+00 433.142
## 122 0.00000e+00 347.072
## 123 0.00000e+00 0.000
## 124 0.00000e+00 0.000
## 125 0.00000e+00 55.692
## 126 0.00000e+00 0.000
## 127 0.00000e+00 67.051
## 128 0.00000e+00 0.000
## 129 0.00000e+00 937.769
## 130 0.00000e+00 335.678
## 131 0.00000e+00 0.000
## 132 0.00000e+00 343.962
## 133 0.00000e+00 0.000
## 134 0.00000e+00 182.626
## 135 0.00000e+00 76.730
## 136 0.00000e+00 0.000
## 137 0.00000e+00 522.411
## 138 0.00000e+00 0.000
## 139 0.00000e+00 0.000
## 140 0.00000e+00 0.000
p <- ggplot(inner_data, aes(x=Date_reported, y=New_cases_pc,color=Country)) +
geom_point() +
xlab("")
p

Ideas on how to improve this
- Create a moving average
- Use the size factor somehow
- Net change?
- Not really handling the NA values well here. Lets just assume they are all 0 if NA
- Seems we are missing some values for GDP??
inner_data %>% #filter(inner_data$Date_reported < '2020-10-02') %>%
plot_ly(
x= ~New_cases_pc,
y= ~GDP,
frame = ~Date_reported,
text=~Country,
hoverinfo="Country",
color=~Country,
type = 'scatter',
mode = 'markers+text',
showlegend = T
)
## Warning: `arrange_()` is deprecated as of dplyr 0.7.0.
## Please use `arrange()` instead.
## See vignette('programming') for more help
## This warning is displayed once every 8 hours.
## Call `lifecycle::last_warnings()` to see where this warning was generated.
## Warning in RColorBrewer::brewer.pal(N, "Set2"): n too large, allowed maximum for palette Set2 is 8
## Returning the palette you asked for with that many colors
## Warning in RColorBrewer::brewer.pal(N, "Set2"): n too large, allowed maximum for palette Set2 is 8
## Returning the palette you asked for with that many colors
- Talk to group about missing GDP values and figure out if taking these values after the quarter date or prior to the quarter date